Power BI Introduction
- Data Visualization
- Reporting
- Business Intelligence (BI)
- Flow of Work in Power BI Desktop
- Flow of Work in Report server Power BI Desktop
- Power BI Report Server, Power BI Service
- Power BI Mobile
- The flow of Work in Power BI / Power BI Architecture
PBI Desktop Installation, PBI Desktop & Service Overview
- Power BI Desktop Installation
- Datasets, Visualizations
- Reports
- Dashboards
- Power BI Desktop User Interface
- Fields Pane,
- Visualizations pane
- Ribbon
- Views
- Pages Tab
- Overview of Power Query / Query Editor - Extract, Transform & Load Data
- Connecting to Data Sources, Establish a connection to the Excel source
- Importing Data into Power BI or Query Editor
- Transforming the Data using Power Query
- Creating new measures, new columns & tables using DAX – Data View
- Saving & Publishing the Visuals or Reports
- Logon to Power BI Service
- View the Reports in PBI Service and Share the reports
Power Query
Introduction to Power Query – Extract, Transform & Load
- Data Transformation,
- Benefits of Data Transformation
- Shape or Transform Data using Power Query
- Overview of Power Query / Query Editor
- Query Editor User Interface
- The Ribbon (Home, Transform, Add Column, View Tabs)
- The Queries Pane, The Data View / Results Pane
- The Query Settings Pane
- Formula Bar
- Advanced Editor – Complete ETL Code
- Saving Your Work – Appling ETL Changes – Loading into Power Pivot Model
- Power Query Conceptually
Datatypes and Filters in Power Query
- Datatypes,
- Changing the Datatype of a Column
- Filters in Power Query
- Filter a Column using Text Filters
- Filter a Column using Number Filters
- Filter a Column using Date Filters
- Filter Multiple Columns
Inbuilt Column Transformations
- Remove Columns / Remove Other Columns
- Name / Rename a Column
- Reorder Columns or Sort Columns
- Add Column / Custom Column
- Split Columns
- Merge Column
- PIVOT,
- UNPIVOT Columns
- Transpose Columns
- Header Row or use first row as headers
- Keep top rows, keep bottom rows
- Keep Range of Rows
- Keep Duplicates, Keep Errors
- Remove Top Rows, Remove Bottom Rows
- Remove Alternative Rows
- Remove Duplicates, Remove Blank Rows
- Remove Errors
- Group By
Combine Queries (Append Queries & Merge Queries)
- Append Queries / Merge Queries
- Query Options
- Copy Query, Paste Query
- Delete Query, Rename Query
- Enable Load, Include in report Refresh
- Duplicate Query, Reference Query
- Move to Group, Move Up, Move Down
Power Pivot
- Power BI Data Modelling – Relationship View
- Data Modelling Introduction
- Relationship
- Need for Relationship
- Relationship Types / Cardinality in General
- One-to-One, One-to-Many (or Many-to-One)
- Many-to-Many
- AutoDetect the relationship
- create a new relationship
- Edit existing relationships
- Make Relationship Active or Inactive
- Delete a relationship
Enhancing the Data Model – DAX
- What is DAX
- Measures
- DAX Table and Column Name Syntax
- Creating Calculated Columns
- Creating Measures
- Calculated Columns Vs Measures
- DAX Syntax & Operators
- DAX Operators
- Types of Operators
- Arithmetic Operators
- Comparison Operators
- Text Concatenation Operator
- Logical Operators
DAX Functions Categories
- Date and Time Functions
- Logical Functions
- Text Functions
- Math & Statistical Functions
- Filter Functions
- Time Intelligence Functions
- DAX Date & Time Functions
- Information Functions
Date and Time Functions
- Year
- Month
- Day
- Weekday
- Weeknum
- Format (Text Function) Month Name
- Weekday Name
- Date
- Today
- Now
- Hour
- Minute
- Second
- Time
- Davidoff
- Calendar
- Date value
- Time value
- Utcnow
- Utctoday
DAX Text Functions
- Len
- Concatenate
- Left
- Right
- Mid
- Upper
- Lower
- Trim
- Substitute
- Blank
- Code
- Exact
- Find
- Fixed
- Trim
- Unichar
- Search
- Value
- Format
DAX Logical Functions
- If
- True
- False
- If error
- In
- Switch
- And
- Not
DAX Math and Statistical Functions
- Currency
- Rand
- Int
- Abs
- Round
- Roundup
- Rounddown
- Rand Between
- Divide
- Even
- Odd
- Sqrt
- Fact
- Sum
- Sumx
- Min
- Minx
- Count
- Countx
- Average
- Averagex
- Countrows
- Countblank
- Crossjoin
- Distinctcount
- Median
- Rankx
- Topn
Other Functions
- Converet
- Datatable
- Generateserie
- Groupby
- Union
- Var
DAX Filter Functions
- Calculate
- Allxecpt
- All
- Distinctcount
- Filter
- Hasonefilter
- Hasonevalue
- Selectedvalue
DAX Time Intelligence Functions
- Time Intelligence Introduction
- Closingbalancemonth
- Dateadd
- Datesbetween
- Datesinperiod
- Datesmtd
- Datesytd
- Totalmtd
- Totalytd
- Endofmonth
- Firstdate
- Lastdate
- Startofmonth
- Sameperiodlastyear
Information Functions
- Contains
- Isblank
- Iserror
- Iseven
- Isnontext
- Istext
- Isodd
- Isnumber
- Username
Power Bi Desktop
Tool Tips
- Felid level tool tips
- Default tool tips
- Page level tool tips
- Text level tool tips
- Visual header tool tips
Conditional Formatting
- Text conditional formatting
- Border conditional formatting
- Background conditional formatting
- Font conditional formatting
- Data bars conditional formatting
- Conditional formatting icons
Other Options
- Buttons
- shapes
- Images
- New parameter
- What if parameter
- Gridlines
- Lock objects
- Bookmarks
- Selection
- Performance analyser
- Sync slicers
- edit interactions
- Enter data
- recent sources
- refresh
- Data grouping
- visual analysing
Visualizations
- Stacked bar chart
- Stacked column chart
- Clustered bar chart
- Clustered column chart
- 100% stacked bar chart
- 100% stacked column chart
- Line chart, Area chart
- Stacked area chart
- Line and stacked column chart
- Line and clustered column chart
- Ribbon chart
- Waterfall chart
- Scatter chart
- Pie chart,
- Donut chart
- Treemap
- Filled map
- Map, Funnel
- Introduction to office 365
- What is office 365
- Download custom visuals
Custom Visuals
- Bar chart,
- Chartaccentbarchart
- Hierarchy slicer
- Linedotchart
- Multi slicer
- Pivotslicer table heatmap
- Tornado chart
Filters in Power View
Filter Types
- Visual Level Filters
- Page Level Filters
- Report Level Filters
- Drill Through Filters
- Filter Sub Types
- Basic Filtering
- Advanced Filtering
- Top N
- Relative Date Filtering
- Numeric field filters
- Text field filters
- Date and Time field Filters
Hierarchies and Drill-Down Reports
- Hierarchy Introduction,
- Default Date Hierarchy,
- Creating Hierarchy,
- Creating Custom Date Hierarchy
- Change Hierarchy Levels
- Drill-Up and Drill-Down Reports,
- Drill Down,
- Drill Up,
- Show Next Level,
- Expand Next Level
- Drilling filters other visuals option
Visualizing KPI Data
- Create and Format Gauge Visual
- KPI Visual
- Create and Format Card Visualization
- Multi Row Card
- Create and Format Table Visual
- Matrix Visualization
- Create and Format Map Visual
- Filled Map Visual
Power BI Service
- Power BI Service Introduction
- Power BI Service Introduction
- Power BI Cloud Architecture
- Creating Power BI Service Account
- SIGN IN to Power BI Service Account
- Publishing Reports to the Power BI service
- Import / Getting the Report to PBI Service
- My Workspace / App Workspaces Tabs
- Working with Datasets
- Creating Reports in Cloud using Published Datasets
- Power BI Datasets Live Connection using Desktop
- working with Reports
- Sharing Reports
- Creating new reports in services
- Embedding to web
- share report link
Dashboards Development
- Creating Dashboards Pin Visuals and Pin LIVE Report Pages to Dashboard
- Advantages of Dashboards
- Interacting with Dashboards
- Formatting Dashboard
- Sharing Dashboard
Data Gateways
- Introduction to Data Gateways
- How Data Gateways work
- Connect to an on-premise Data Source by using a Data Gateway
- Download Data Gateway
- Installing a Data Gateway
- Types of Gateways
- On-premises Data Gateway, On-premises Data Gateway (personal mode)
- Manage Data Gateway
- Refresh on Premise Data
Configuring Automatic Refresh using Schedules
- Collaboration in Power BI using App Workspace
- Introduction to App Workspaces
- Create an App Workspace
- Add Members to App Workspace to Collaborate
- App Workspace Access
- Admin, Member,
- Contributor
Sharing Power BI Content using Apps and Content Packs
- Introduction to App
- Publish an App
- Update a Published App
- Manage Content in App
- Entire Organization,
- Specific individuals or group
- Content Pack Introduction
- Create Content Pack
- Sharing Content Packs
- Specific Groups
- My Entire Organization
- Selecting the Content / Items to Publish or Share
- Row Level Security in Power BI
- Introduction to Row Level Security